package com.example.sale.Mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.example.sale.True.Feedback;
import com.example.sale.True.Payment;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

@Mapper
public interface PaymentMapper extends BaseMapper<Payment> {
    @Select("select SUM(Price) from payment")
    Integer countSumPrice();
    @Select("select AVG(Price) from payment")
    Integer countAvgPrice();
    @Select("select Max(Price) from payment")
    Integer countMaxPrice();
    @Select("select Min(Price) from payment")
    Integer countMinPrice();
}
